Page History: Collateral Report
Compare Page Revisions
Page Revision: 2012/12/18 08:50
Application ReportsThe Collateral Report message (MsgTyp=BA) responds to the
Collateral Inquiry message by listing detail information about accounts position, account updates, accoung permissions and financial balanes. Reports can generated as the result of the following events,
* Listing Account Details for a connected User
* Account Subscription Requests
* Account Updates
* Account Position Updates
Responding to the Request to List User AccountsA
Collateral Inquiry request for a list of accounts (MsgType=BB with Tag 263=0) returns Collateral Reports for each of the account the user has access to. The Account name is specified in the Accounts field (Tag 1). The corresponding AccountID is specified in the PartyID (Tag 448). Basic Balance information (e.g. Start Cash=Tag 921) is also provided. This report is differentiated by its Quantity Type equal to Account-List (Tag 854=1).
Responding to Account Subscription RequestA
Collateral Inquiry request to subscribe to User Accounts (MsgType=BB with Tag 263=1) returns a combinations of Collateral Reports,
Execution Reports and
Security Definitions for orders, fills, positions, account details, account updates and account position updates. The Collateral Report message provides information on the following categories:
1. Account Details
Account Details carry information in account privileges, account permission and account configuration. This report is differentiated by its Quantity Type equal to Account-Details (Tag 854=2).
2. Account Updates
Account Updates carry information in the instantaneous state of account Balances as Start Cash, Margin Requirements, etc. This report is differentiated by its Quantity Type equal to Account-Update (Tag 854=3). Note that Account Updates can be generated asynchronously without a preceding Collateral Inquiry.
3. Account Position Updates
Account Position Updates carry information on the combination of all open positions, working orders and fills for a given security within an account. Among other fields, this type of Collateral Report provides balances on working orders with number of buys and sells (Tags 3002 and 3003), number of short and long positions (Tag 53) and Open Volume (Tag 3011). This report is differentiated by its Quantity Type equal to Account-Position-Update (Tag 854=4). Note that Account Position Updates can be generated asynchronously without a preceding
Collateral Inquiry.
| Tag | Field Name | Req'd | Comments |
|---|
| Standard Header | Y | MsgType = BB |
| 908 | CollInquiryID | N | Unique identifier for the collateral inquiry that generated this report. |
| 909 | CollReportID | Y | Unique identifier for this report. |
| 910 | CollStatus | N | Status of Entity carried by this report. |
| 911 | TotNumReports | N | Total number of Collateral Reports associated with its Collateral Inquiry. |
| 912 | LastReportRequested | N | Indicator whether this report is that last in the series of TotNumReports (Tag 911). |
| 1 | Account | N | Account for which this report pertains. |
| | Start Repeating Group | |
| 453 | NoPartyIDs | N | Number of PartyIDs fields requested. Repeating Group. |
| 448 | PartyID | Y | PartyID as applicable to the Party Role (Tag 452): |
| 452 | PartyRole | N | Identifies the Type of PartyID. The valid values are: |
| | | 24 = Customer Account |
| | | 3 = Order Id |
| | End Repeating Group | |
| | Start Repeating Group | |
| 136 | NoMiscFees|| N | Number of repeating groups of miscellaneous fees |
| 137 | MiscFeeAmt | Y | Miscellaneous fee value. |
| 138 | MiscFeeCurr | Y | Currency of miscellaneous fee |
| 139 | MiscFeeType | Y | Indicates type of miscellaneous fee. |
| 891 | MiscFeeBasis | Y | Defines the unit for a miscellaneous fee. The valid values are: |
| | | 0 = Absolute |
| | | 1 = Per Unit |
| | | 2 = Percentage |
| | End Repeating Group | |
| 58 | Text | N | Free form Text. |
| | Standard Trailer | Y |
Sample MessagesListing User Accounts
[FIXCOLLATERALINQUIRY] 34=63|49=T4Test|56=test|52=20121217-18:28:36.695|909=ci-12/17/2012 12:28:36 PM|263=0|725=0|453=1|448=9A65B2FE-1D27-4230-A942-F60983CFB33B|452=24|938=1|896=0|
[MsgSeqNum] 34 = 63
[SenderCompID] 49 = T4Test
[TargetCompID] 56 = test
[SendingTime] 52 = 20121217-18:28:36.695
[CollInquiryID] 909 = ci-12/17/2012 12:28:36 PM
[SubscriptionRequestType] 263 = 0 (SNAPSHOT)
[ResponseTransportType] 725 = 0 (IN_BAND)
[NoPartyIDs] 453 = 1
[PartyID] 448 = 9A65B2FE-1D27-4230-A942-F60983CFB33B
[PartyRole] 452 = 24 (CUSTOMER_ACCOUNT)
[NoCollInquiryQualifier] 938 = 1
[CollInquiryQualifier] 896 = 0 (CUSTOMER_ACCOUNTS)
[fixcollateralreport] 34=194|49=test|56=T4Test|50=T4FIX|52=20121217-18:28:36.741|908=cr-634913441167419740|909=ci-12/17/2012 12:18:55 PM|910=Unrestricted|911=3|912=N|1=ernesto|453=1|448=9A65B2FE-1D27-4230-A942-F60983CFB33B|136=1|137=5|899=-3126074.92232|900=-1025|921=-3082864.92232|854=1|
[MsgSeqNum] 34 = 194
[SenderCompID] 49 = test
[TargetCompID] 56 = T4Test
[SenderSubID] 50 = T4FIX
[SendingTime] 52 = 20121217-18:28:36.741
[CollRptID] 908 = cr-634913441167419740
[CollInquiryID] 909 = ci-12/17/2012 12:18:55 PM
[CollStatus] 910 = Unrestricted
[TotNumReports] 911 = 3
[LastRptRequested] 912 = N (NO)
[Account] 1 = ernesto
[NoPartyIDs] 453 = 1
[PartyID] 448 = 9A65B2FE-1D27-4230-A942-F60983CFB33B
[NoMiscFees] 136 = 1
[MiscFeeAmt] 137 = 5
[MarginExcess] 899 = -3126074.92232
[TotalNetValue] 900 = -1025
[StartCash] 921 = -3082864.92232
[QtyType] 854 = 1 (ACCOUNT_LIST)
Subscribing To Accounts
[FIXCOLLATERALINQUIRY] 34=67|49=T4Test|56=test|52=20121217-18:30:13.875|909=ci-12/17/2012 12:30:13 PM|263=1|725=0|453=2|448=9A65B2FE-1D27-4230-A942-F60983CFB33B|452=24|448=69CA7C3F-DAD4-453A-8521-F815F11DD201|452=24|938=1|896=0|
[MsgSeqNum] 34 = 67
[SenderCompID] 49 = T4Test
[TargetCompID] 56 = test
[SendingTime] 52 = 20121217-18:30:13.875
[CollInquiryID] 909 = ci-12/17/2012 12:30:13 PM
[SubscriptionRequestType] 263 = 1 (SNAPSHOT_PLUS_UPDATES)
[ResponseTransportType] 725 = 0 (IN_BAND)
[NoPartyIDs] 453 = 2
[PartyID] 448 = 9A65B2FE-1D27-4230-A942-F60983CFB33B
[PartyRole] 452 = 24 (CUSTOMER_ACCOUNT)
[PartyID] 448 = 69CA7C3F-DAD4-453A-8521-F815F11DD201
[PartyRole] 452 = 24 (CUSTOMER_ACCOUNT)
[NoCollInquiryQualifier] 938 = 1
[CollInquiryQualifier] 896 = 0 (CUSTOMER_ACCOUNTS)
[fixcollateralreport] 34=200|49=test|56=T4Test|50=T4FIX|52=20121217-18:30:16.200|908=cr-634913442162000522|909=ci-12/17/2012 12:28:36 PM|910=3|911=1|912=Y|1=test4|453=1|448=69CA7C3F-DAD4-453A-8521-F815F11DD201|136=1|137=-1|139=N|854=2|3100=69CA7C3F-DAD4-453A-8521-F815F11DD201|3101=test4|3104=-1|3105=0|3106=N|3108=N|3110=Y|3111=test|3112=2884B215-4A4B-4E9D-A40E-F8212D713E13|3113=100|3114=0|3115=100|3116=-1|3117=1000|3118=-1|3119=-1|3120=0|3121=C|3122=N|3123=100|3124=2884B215-4A4B-4E9D-A40E-F8212D713E13|3125=Y|3126=Y|3127=Y|3128=Y|3129=N|3130=N|3131=1000|3132=-1|3133=100|3134=100|3135=Y|3136=-1|3137=50|3138=10|3139=-1|12=0|
[MsgSeqNum] 34 = 200
[SenderCompID] 49 = test
[TargetCompID] 56 = T4Test
[SenderSubID] 50 = T4FIX
[SendingTime] 52 = 20121217-18:30:16.200
[CollRptID] 908 = cr-634913442162000522
[CollInquiryID] 909 = ci-12/17/2012 12:28:36 PM
[CollStatus] 910 = 3 (ASSIGNED)
[TotNumReports] 911 = 1
[LastRptRequested] 912 = Y (YES)
[Account] 1 = test4
[NoPartyIDs] 453 = 1
[PartyID] 448 = 69CA7C3F-DAD4-453A-8521-F815F11DD201
[NoMiscFees] 136 = 1
[MiscFeeAmt] 137 = -1
[MiscFeeType] 139 = N
[QtyType] 854 = 2 (ACCOUNT_DETAILS)
[AccountID] 3100 = 69CA7C3F-DAD4-453A-8521-F815F11DD201
[AccountName] 3101 = test4
[BlockExpiring] 3104 = -1
[DayLossLimit] 3105 = 0
[Deleted] 3106 = N
[EditMargin] 3108 = N
[Enabled] 3110 = Y
[Firm] 3111 = test
[FirmID] 3112 = 2884B215-4A4B-4E9D-A40E-F8212D713E13
[LossLimit] 3113 = 100
[LossLimitPC] 3114 = 0
[MarginPC] 3115 = 100
[MaxAccountPosition] 3116 = -1
[MaxClipSize] 3117 = 1000
[MaxContractMargin] 3118 = -1
[MaxPosition] 3119 = -1
[MinBalance] 3120 = 0
[Mode] 3121 = C
[OrderRouting] 3122 = N
[OvernightMarginPC] 3123 = 100
[ParentFirmID] 3124 = 2884B215-4A4B-4E9D-A40E-F8212D713E13
[PLRollover] 3125 = Y
[PositionRollover] 3126 = Y
[PreTradeDisabled] 3127 = Y
[RiskAlerts] 3128 = Y
[RiskDebug] 3129 = N
[RiskDebugOrders] 3130 = N
[StrategyMaxClipSize] 3131 = 1000
[StrategyMaxPosition] 3132 = -1
[StrategyTotalPitTrades] 3133 = 100
[TotalPitTrades] 3134 = 100
[UsePLForMargin] 3135 = Y
[WarningThresholdLossLimit] 3136 = -1
[WarningThresholdMargin] 3137 = 50
[WarningThresholdPL] 3138 = 10
[WideMarket] 3139 = -1
[Commission] 12 = 0
[fixcollateralreport] 34=202|49=test|56=T4Test|50=T4FIX|52=20121217-18:30:16.200|908=cr-634913442162000522|909=ci-12/17/2012 12:28:36 PM|911=1|912=Y|1=test4|453=1|448=69CA7C3F-DAD4-453A-8521-F815F11DD201|136=1|137=0|899=4375|900=0|901=0|53=1 1 0|854=4|55=ES|48=CME_20121200_ESZ2|207=CME_Eq|200=201212|167=FUT|75=20121217|3000=1|3001=0|3002=0|3003=0|3004=2737.5|3005=136325|3006=1|3007=1|3008=136325|3009=0|3010=136325|3011=1|
[MsgSeqNum] 34 = 202
[SenderCompID] 49 = test
[TargetCompID] 56 = T4Test
[SenderSubID] 50 = T4FIX
[SendingTime] 52 = 20121217-18:30:16.200
[CollRptID] 908 = cr-634913442162000522
[CollInquiryID] 909 = ci-12/17/2012 12:28:36 PM
[TotNumReports] 911 = 1
[LastRptRequested] 912 = Y (YES)
[Account] 1 = test4
[NoPartyIDs] 453 = 1
[PartyID] 448 = 69CA7C3F-DAD4-453A-8521-F815F11DD201
[NoMiscFees] 136 = 1
[MiscFeeAmt] 137 = 0
[MarginExcess] 899 = 4375
[TotalNetValue] 900 = 0
[CashOutstanding] 901 = 0
[Shares] 53 = 1 1 0
[QtyType] 854 = 4 (ACCOUNT_POSITION_UPDATE)
[Symbol] 55 = ES
[SecurityID] 48 = CME_20121200_ESZ2
[SecurityExchange] 207 = CME_Eq
[MaturityMonthYear] 200 = 201212
[SecurityType] 167 = FUT (FUTURE)
[TradeDate] 75 = 20121217
[Buys] 3000 = 1
[Sells] 3001 = 0
[WorkingBuys] 3002 = 0
[WorkingSells] 3003 = 0
[OvernightUPL] 3004 = 2737.5
[AverageOpenTicks] 3005 = 136325
[OvernightPosition] 3006 = 1
[CurrencyRate] 3007 = 1
[TotalBuyFillTicks] 3008 = 136325
[TotalSellFillTicks] 3009 = 0
[TotalOpenTicks] 3010 = 136325
[TotalOpenVolume] 3011 = 1
Unsubscribe from Accounts
[FIXCOLLATERALINQUIRY] 34=69|49=T4Test|56=test|52=20121217-18:31:14.107|909=ci-12/17/2012 12:31:14 PM|263=2|725=0|453=2|448=9A65B2FE-1D27-4230-A942-F60983CFB33B|452=24|448=69CA7C3F-DAD4-453A-8521-F815F11DD201|452=24|938=1|896=0|
[MsgSeqNum] 34 = 69
[SenderCompID] 49 = T4Test
[TargetCompID] 56 = test
[SendingTime] 52 = 20121217-18:31:14.107
[CollInquiryID] 909 = ci-12/17/2012 12:31:14 PM
[SubscriptionRequestType] 263 = 2 (DISABLE_PREVIOUS_SNAPSHOT_PLUS_UPDATE_REQUEST)
[ResponseTransportType] 725 = 0 (IN_BAND)
[NoPartyIDs] 453 = 2
[PartyID] 448 = 9A65B2FE-1D27-4230-A942-F60983CFB33B
[PartyRole] 452 = 24 (CUSTOMER_ACCOUNT)
[PartyID] 448 = 69CA7C3F-DAD4-453A-8521-F815F11DD201
[PartyRole] 452 = 24 (CUSTOMER_ACCOUNT)
[NoCollInquiryQualifier] 938 = 1
[CollInquiryQualifier] 896 = 0 (CUSTOMER_ACCOUNTS)
Listing Order History
[FIXCOLLATERALINQUIRY] 34=77|49=T4Test|56=test|52=20121217-18:32:51.716|909=ci-12/17/2012 12:32:51 PM|263=0|453=1|448=37CB0FDB-09C7-4080-B74E-5FFC7DD360EB|452=3|938=1|896=3|
[MsgSeqNum] 34 = 77
[SenderCompID] 49 = T4Test
[TargetCompID] 56 = test
[SendingTime] 52 = 20121217-18:32:51.716
[CollInquiryID] 909 = ci-12/17/2012 12:32:51 PM
[SubscriptionRequestType] 263 = 0 (SNAPSHOT)
[NoPartyIDs] 453 = 1
[PartyID] 448 = 37CB0FDB-09C7-4080-B74E-5FFC7DD360EB
[PartyRole] 452 = 3 (ORDER_ID)
[NoCollInquiryQualifier] 938 = 1
[CollInquiryQualifier] 896 = 3 (ACCOUNT_ORDERS)
[fixexecutionreport] 34=295|49=test|56=T4Test|50=T4FIX|52=20121217-18:32:51.747|143=CME_Eq|369=1|1=ernesto|11=fn-63491344366521916|41=fn-63491344366521916|17=1.CME_Eq..599266080000000000|150=A|37=37CB0FDB-09C7-4080-B74E-5FFC7DD360EB|39=A|48=CME_20121200_ESZ2|55=ES|207=CME_Eq|200=201212|59=0|107=E-mini S&P 500 Dec12|54=1|167=FUT|38=1|40=2|44=141400|58=SubmissionRiskSuccess. Order passed risk management|60=20121217-18:33:09.000|21=1|
[MsgSeqNum] 34 = 295
[SenderCompID] 49 = test
[TargetCompID] 56 = T4Test
[SenderSubID] 50 = T4FIX
[SendingTime] 52 = 20121217-18:32:51.747
[TargetLocationID] 143 = CME_Eq
[LastMsgSeqNumProcessed] 369 = 1
[Account] 1 = ernesto
[ClOrdID] 11 = fn-63491344366521916
[OrigClOrdID] 41 = fn-63491344366521916
[ExecID] 17 = 1.CME_Eq..599266080000000000
[ExecType] 150 = A (PENDING_NEW)
[OrderID] 37 = 37CB0FDB-09C7-4080-B74E-5FFC7DD360EB
[OrdStatus] 39 = A (PENDING_NEW)
[SecurityID] 48 = CME_20121200_ESZ2
[Symbol] 55 = ES
[SecurityExchange] 207 = CME_Eq
[MaturityMonthYear] 200 = 201212
[TimeInForce] 59 = 0 (DAY)
[SecurityDesc] 107 = E-mini S&P 500 Dec12
[Side] 54 = 1 (BUY)
[SecurityType] 167 = FUT (FUTURE)
[OrderQty] 38 = 1
[OrdType] 40 = 2 (LIMIT)
[Price] 44 = 141400
[Text] 58 = SubmissionRiskSuccess. Order passed risk management
[TransactTime] 60 = 20121217-18:33:09.000
[HandlInst] 21 = 1 (AUTOMATED_EXECUTION_ORDER_PRIVATE_NO_BROKER_INTERVENTION)
[fixexecutionreport] 34=296|49=test|56=T4Test|50=T4FIX|52=20121217-18:32:51.763|143=CME_Eq|369=2|1=ernesto|11=fn-63491344366521916|41=fn-63491344366521916|17=2.CME_Eq..599266080000000000|150=A|37=37CB0FDB-09C7-4080-B74E-5FFC7DD360EB|39=A|48=CME_20121200_ESZ2|55=ES|207=CME_Eq|200=201212|59=0|107=E-mini S&P 500 Dec12|54=1|167=FUT|38=1|40=2|44=141400|58=SubmissionSent. Order was submitted to the exchange|60=20121217-18:33:09.000|21=1|
[MsgSeqNum] 34 = 296
[SenderCompID] 49 = test
[TargetCompID] 56 = T4Test
[SenderSubID] 50 = T4FIX
[SendingTime] 52 = 20121217-18:32:51.763
[TargetLocationID] 143 = CME_Eq
[LastMsgSeqNumProcessed] 369 = 2
[Account] 1 = ernesto
[ClOrdID] 11 = fn-63491344366521916
[OrigClOrdID] 41 = fn-63491344366521916
[ExecID] 17 = 2.CME_Eq..599266080000000000
[ExecType] 150 = A (PENDING_NEW)
[OrderID] 37 = 37CB0FDB-09C7-4080-B74E-5FFC7DD360EB
[OrdStatus] 39 = A (PENDING_NEW)
[SecurityID] 48 = CME_20121200_ESZ2
[Symbol] 55 = ES
[SecurityExchange] 207 = CME_Eq
[MaturityMonthYear] 200 = 201212
[TimeInForce] 59 = 0 (DAY)
[SecurityDesc] 107 = E-mini S&P 500 Dec12
[Side] 54 = 1 (BUY)
[SecurityType] 167 = FUT (FUTURE)
[OrderQty] 38 = 1
[OrdType] 40 = 2 (LIMIT)
[Price] 44 = 141400
[Text] 58 = SubmissionSent. Order was submitted to the exchange
[TransactTime] 60 = 20121217-18:33:09.000
[HandlInst] 21 = 1 (AUTOMATED_EXECUTION_ORDER_PRIVATE_NO_BROKER_INTERVENTION)
[fixexecutionreport] 34=297|49=test|56=T4Test|50=T4FIX|52=20121217-18:32:51.763|143=CME_Eq|369=3|1=ernesto|11=fn-63491344366521916|41=fn-63491344366521916|17=3.CME_Eq.71334700524_ESZ2.634913443890000000|150=0|37=37CB0FDB-09C7-4080-B74E-5FFC7DD360EB|39=0|48=CME_20121200_ESZ2|55=ES|207=CME_Eq|200=201212|59=0|107=E-mini S&P 500 Dec12|54=1|167=FUT|38=1|40=2|44=141400|60=20121217-18:33:09.000|21=1|
[MsgSeqNum] 34 = 297
[SenderCompID] 49 = test
[TargetCompID] 56 = T4Test
[SenderSubID] 50 = T4FIX
[SendingTime] 52 = 20121217-18:32:51.763
[TargetLocationID] 143 = CME_Eq
[LastMsgSeqNumProcessed] 369 = 3
[Account] 1 = ernesto
[ClOrdID] 11 = fn-63491344366521916
[OrigClOrdID] 41 = fn-63491344366521916
[ExecID] 17 = 3.CME_Eq.71334700524_ESZ2.634913443890000000
[ExecType] 150 = 0 (NEW)
[OrderID] 37 = 37CB0FDB-09C7-4080-B74E-5FFC7DD360EB
[OrdStatus] 39 = 0 (NEW)
[SecurityID] 48 = CME_20121200_ESZ2
[Symbol] 55 = ES
[SecurityExchange] 207 = CME_Eq
[MaturityMonthYear] 200 = 201212
[TimeInForce] 59 = 0 (DAY)
[SecurityDesc] 107 = E-mini S&P 500 Dec12
[Side] 54 = 1 (BUY)
[SecurityType] 167 = FUT (FUTURE)
[OrderQty] 38 = 1
[OrdType] 40 = 2 (LIMIT)
[Price] 44 = 141400
[TransactTime] 60 = 20121217-18:33:09.000
[HandlInst] 21 = 1 (AUTOMATED_EXECUTION_ORDER_PRIVATE_NO_BROKER_INTERVENTION)
FIX API Home Page.
[fixcollateralreport] 34=145|49=test|56=T4Test|50=T4FIX|52=20121214-23:43:38.216|908=cr-634911038181694650|909=ci-12/14/2012 5:43:33 PM|911=1|912=Y|1=ernesto|453=1|448=9A65B2FE-1D27-4230-A942-F60983CFB33B|136=1|137=0|899=7560|900=0|901=0|53=2 0 -2|854=4|55=ZB|48=CME_20121200_ZBZ2|207=CME_F|200=201212|167=FUT|75=20121217|3000=0|3001=2|3002=0|3003=0|3004=1625|3005=15000000|3006=-2|3007=1|3008=0|3009=30000000|3010=30000000|3011=2|
[FIXCOLLATERALREPORT]
[MsgSeqNum] 34 = 145
[SenderCompID] 49 = test
[TargetCompID] 56 = T4Test
[SenderSubID] 50 = T4FIX
[SendingTime] 52 = 20121214-23:43:38.216
[CollRptID] 908 = cr-634911038181694650
[CollInquiryID] 909 = ci-12/14/2012 5:43:33 PM
[TotNumReports] 911 = 1
[LastRptRequested] 912 = Y (YES)
[Account] 1 = ernesto
[NoPartyIDs] 453 = 1
[PartyID] 448 = 9A65B2FE-1D27-4230-A942-F60983CFB33B
[NoMiscFees] 136 = 1
[MiscFeeAmt] 137 = 0
[MarginExcess] 899 = 7560
[TotalNetValue] 900 = 0
[CashOutstanding] 901 = 0
[Shares] 53 = 2 0 -2
[QtyType] 854 = 4 (ACCOUNT_POSITION_UPDATE)
[Symbol] 55 = ZB
[SecurityID] 48 = CME_20121200_ZBZ2
[SecurityExchange] 207 = CME_F
[MaturityMonthYear] 200 = 201212
[SecurityType] 167 = FUT (FUTURE)
[TradeDate] 75 = 20121217
[Buys] 3000 = 0
[Sells] 3001 = 2
[WorkingBuys] 3002 = 0
[WorkingSells] 3003 = 0
[OvernightUPL] 3004 = 1625
[AverageOpenTicks] 3005 = 15000000
[OvernightPosition] 3006 = -2
[CurrencyRate] 3007 = 1
[TotalBuyFillTicks] 3008 = 0
[TotalSellFillTicks] 3009 = 30000000
[TotalOpenTicks] 3010 = 30000000
[TotalOpenVolume] 3011 = 2